home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
kermit.columbia.edu
/
kermit.columbia.edu.tar
/
kermit.columbia.edu
/
newsgroups
/
misc.20021006-20030409
/
000213_ekimble@wfl.fha.dot.gov_Tue Jan 14 11:34:18 EST 2003.msg
< prev
next >
Wrap
Text File
|
2003-04-08
|
3KB
|
74 lines
Article: 14003 of comp.protocols.kermit.misc
Path: newsmaster.cc.columbia.edu!phl-feed.news.verio.net!iad-feed.news.verio.net!iad-peer.news.verio.net!news.verio.net!newsfeed.vmunix.org!newspeer1-gui.server.ntli.net!ntli.net!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Eric Kimble <ekimble@wfl.fha.dot.gov>
Newsgroups: comp.databases.oracle.server,comp.security.ssh,comp.terminals,comp.protocols.kermit.misc
Subject: Re: Strange behavior with SQLPLUS (Oracle)
Date: Tue, 14 Jan 2003 08:15:35 -0800
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <3E2437A7.8FBD4FB7@wfl.fha.dot.gov>
X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
References: <a8c29269.0301140753.7ee5175c@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 55
Xref: newsmaster.cc.columbia.edu comp.databases.oracle.server:214778 comp.security.ssh:30772 comp.terminals:17733 comp.protocols.kermit.misc:14003
Roger:
In SQL*Plus, when only wanting to look at a portion of the column you need to
tell the environment to only show the portion that you want. issue a statement
like the following on the SQL*Plus command line
column table_name format a30.
Then read up on column formatting in the documentation at tahiti.oracle.com
Roger Redford wrote:
> I've recently moved to a new environment, and I'm getting some strange
> symptoms with sqlplus. The environment is:
>
> Oracle 9.2, on solaris
> Ibm thinkpad laptop
> Smarterm and Putty
>
> I've used both Smarterm and Putty to connect to unix and use sqlplus. It is
> using SSH, but the symptoms occur whether I am just using telnet, or ssh.
>
> The symptom is:
>
> When do I select some long columns, such as TABLE_OWNER,
> OR table_name, the field takes up a whole line.
>
> IE.
>
> Select table_owner ,
> table_name ,
> partition_name,
> NUM_ROWS,
> LAST_ANALYZED
> from all_tab_partitions
> where NUM_ROWS = 0
> ORDER BY TABLE_OWNER,
> TABLE_NAME,
> PARTITION_NAME
>
> I have tried:
> set linesize 30000
> substr(table_owner, 1, 20) as table_owner
>
> Yet, no matter what I do, the symptoms persist.
>
> Set wrap is on. If I set it off, I will only see the first field.
>
> The crazy thing is, that my neighbors' sqlplus works normally,
> and only returns 30 or less columns.
>
> Is there a setting that I should be concerned about? Is it in
> sqlplus, or in the client software (Putty, or Smarterm)?
>
> Thanks